﻿CREATE PROCEDURE [dbo].[proc_Project_GetList_InterfaceCount]
	(
		@StartDate nvarchar(10),
		@EndDate nvarchar(10),
		@Stext nvarchar(50),
		@UserName nvarchar(50)
	)
AS
	Select Count(Id) From Project
	Where ExecPerson=@UserName and Convert(nchar(10),CreateDate,120) between @StartDate and @EndDate  and  (@Stext='' Or CusName like '%'+@Stext+'%' Or Salesman like '%'+@Stext+'%')
	RETURN
